<cfcomponent extends="assets.calgrants.com.Base">

	<cfscript>
        import assets.calgrants.com.bo.Scholarship;
	</cfscript>
	
	<cffunction name="get" access="public" output="false" returntype="assets.calgrants.com.bo.Scholarship">
		<cfargument name="Scholarship_ID" type="numeric" required="true" />
		<cfscript>
			if (arguments.Scholarship_ID gt 0) {
				local.loadArgs = {};
				local.loadArgs.obj = new Scholarship();
				StructAppend(local.loadArgs, QueryToStruct(read(argumentCollection = arguments))[1]);
				return load(argumentCollection = local.loadArgs);
			} else {
				return new Scholarship();
			}
		</cfscript>
	</cffunction>

	<cffunction name="load" access="public" output="false" returntype="assets.calgrants.com.bo.Scholarship">
		<cfargument name="obj" type="assets.calgrants.com.bo.Scholarship" required="true" />
		<cfscript>
			local.obj = arguments.obj;
			if (IsDefined("arguments.Scholarship_ID")) {
				local.obj.setScholarship_ID(arguments.Scholarship_ID);
			}
			if (IsDefined("arguments.Deleted")) {
				local.obj.setDeleted(arguments.Deleted); 
			}
			if (IsDefined("arguments.Student_ID")) {
				local.obj.setStudent_ID(arguments.Student_ID); 
			}
			if (IsDefined("arguments.Claim_ID")) {
				local.obj.setClaim_ID(arguments.Claim_ID); 
			}
			if (IsDefined("arguments.Claim_Date")) {
				local.obj.setClaim_Date(arguments.Claim_Date); 
			}
			if (IsDefined("arguments.Cohort")) {
				local.obj.setCohort(arguments.Cohort); 
			}
			if (IsDefined("arguments.Scholarship_Type")) {
				local.obj.setScholarship_Type(arguments.Scholarship_Type); 
			}
			if (IsDefined("arguments.PBS")) {
				local.obj.setPBS(arguments.PBS); 
			}
			if (IsDefined("arguments.Research_ID")) {
				local.obj.setResearch_ID(arguments.Research_ID); 
			}
			if (IsDefined("arguments.First_Name")) {
				local.obj.setFirst_Name(arguments.First_Name); 
			}
			if (IsDefined("arguments.Last_Name")) {
				local.obj.setLast_Name(arguments.Last_Name); 
			}
			if (IsDefined("arguments.SSN")) {
				local.obj.setSSN(arguments.SSN); 
			}
			if (IsDefined("arguments.DOB")) {
				local.obj.setDOB(arguments.DOB); 
			}
			if (IsDefined("arguments.Gender")) {
				local.obj.setGender(arguments.Gender); 
			}
			if (IsDefined("arguments.Race_Ethnicity")) {
				local.obj.setRace_Ethnicity(arguments.Race_Ethnicity); 
			}
			if (IsDefined("arguments.Address")) {
				local.obj.setAddress(arguments.Address); 
			}
			if (IsDefined("arguments.City")) {
				local.obj.setCity(arguments.City); 
			}
			if (IsDefined("arguments.Zip_Code")) {
				local.obj.setZip_Code(arguments.Zip_Code); 
			}
			if (IsDefined("arguments.Email")) {
				local.obj.setEmail(arguments.Email); 
			}
			if (IsDefined("arguments.Phone1")) {
				local.obj.setPhone1(arguments.Phone1); 
			}
			if (IsDefined("arguments.Phone2")) {
				local.obj.setPhone2(arguments.Phone2); 
			}
			if (IsDefined("arguments.Password")) {
				local.obj.setPassword(arguments.Password); 
			}
			if (IsDefined("arguments.High_School")) {
				local.obj.setHigh_School(arguments.High_School); 
			}
			if (IsDefined("arguments.High_School_ID")) {
				local.obj.setHigh_School_ID(arguments.High_School_ID); 
			}
			if (IsDefined("arguments.Graduation_Month")) {
				local.obj.setGraduation_Month(arguments.Graduation_Month); 
			}
			if (IsDefined("arguments.Graduation_Year")) {
				local.obj.setGraduation_Year(arguments.Graduation_Year); 
			}
			if (IsDefined("arguments.Volunteer")) {
				local.obj.setVolunteer(arguments.Volunteer); 
			}
			if (IsDefined("arguments.Authorized")) {
				local.obj.setAuthorized(arguments.Authorized); 
			}
			if (IsDefined("arguments.Authorized_By")) {
				local.obj.setAuthorized_By(arguments.Authorized_By); 
			}
			if (IsDefined("arguments.Authorized_Signature")) {
				local.obj.setAuthorized_Signature(arguments.Authorized_Signature); 
			}
			if (IsDefined("arguments.Orientation_Completed")) {
				local.obj.setOrientation_Completed(arguments.Orientation_Completed); 
			}
			if (IsDefined("arguments.Login_Token")) {
				local.obj.setLogin_Token(arguments.Login_Token); 
			}
			if (IsDefined("arguments.Login_Date_Time")) {
				local.obj.setLogin_Date_Time(arguments.Login_Date_Time); 
			}
			if (IsDefined("arguments.Institution1_ID")) {
				local.obj.setInstitution1_ID(arguments.Institution1_ID); 
			}
			if (IsDefined("arguments.Institution2_ID")) {
				local.obj.setInstitution2_ID(arguments.Institution2_ID); 
			}
			if (IsDefined("arguments.Institution3_ID")) {
				local.obj.setInstitution3_ID(arguments.Institution3_ID); 
			}
			if (IsDefined("arguments.Enrollment_Date")) {
				local.obj.setEnrollment_Date(arguments.Enrollment_Date); 
			}
			if (IsDefined("arguments.Attendance_Level")) {
				local.obj.setAttendance_Level(arguments.Attendance_Level); 
			}
			if (IsDefined("arguments.Degree_Level")) {
				local.obj.setDegree_Level(arguments.Degree_Level); 
			}
			if (IsDefined("arguments.Notes")) {
				local.obj.setNotes(arguments.Notes); 
			}
			if (IsDefined("arguments.Payment_Method")) {
				local.obj.setPayment_Method(arguments.Payment_Method); 
			}
			if (IsDefined("arguments.Account_Type")) {
				local.obj.setAccount_Type(arguments.Account_Type); 
			}
			if (IsDefined("arguments.Routing_Number")) {
				local.obj.setRouting_Number(arguments.Routing_Number); 
			}
			if (IsDefined("arguments.Account_Number")) {
				local.obj.setAccount_Number(arguments.Account_Number); 
			}
			/*if (IsDefined("arguments.GDS_Match")) {
				local.obj.setGDS_Match(arguments.GDS_Match); 
			}
			if (IsDefined("arguments.AB540")) {
				local.obj.setAB540(arguments.AB540); 
			}*/
			if (IsDefined("arguments.Date_Created")) {
				local.obj.setDate_Created(arguments.Date_Created);
			}
			if (IsDefined("arguments.Claim_Status")) {
				local.obj.setClaim_Status(arguments.Claim_Status);
			}			
			return local.obj;
		</cfscript>
	</cffunction>

	<cffunction name="read" access="public" output="false" returntype="any">
		<cfargument name="Scholarship_ID" required="false" default="" />
		<cfargument name="Deleted" required="false" default="0" />
		<cfargument name="Student_ID" required="false" default="" />
		<cfargument name="Claim_ID" required="false" default="" />
		<cfargument name="Claim_Date" required="false" default="" />
		<cfargument name="Cohort" required="false" default="" />
		<cfargument name="Scholarship_Type" required="false" default="" />
		<cfargument name="PBS" required="false" default="" />
		<cfargument name="Research_ID" required="false" default="" />
		<cfargument name="First_Name" required="false" default="" />
		<cfargument name="Last_Name" required="false" default="" />
		<cfargument name="SSN" required="false" default="" />
		<cfargument name="DOB" required="false" default="" />
		<cfargument name="Gender" required="false" default="" />
		<cfargument name="Race_Ethnicity" required="false" default="" />
		<cfargument name="Address" required="false" default="" />
		<cfargument name="City" required="false" default="" />
		<cfargument name="Zip_Code" required="false" default="" />
		<cfargument name="Email" required="false" default="" />
		<cfargument name="Phone1" required="false" default="" />
		<cfargument name="Phone2" required="false" default="" />
		<cfargument name="Password" required="false" default="" />
		<cfargument name="High_School" required="false" default="" />
		<cfargument name="High_School_ID" required="false" default="" />
		<cfargument name="Graduation_Month" required="false" default="" />
		<cfargument name="Graduation_Year" required="false" default="" />
		<cfargument name="Volunteer" required="false" default="" />
		<cfargument name="Authorized" required="false" default="" />
		<cfargument name="Authorized_By" required="false" default="" />
		<cfargument name="Authorized_Signature" required="false" default="" />
		<cfargument name="Orientation_Completed" required="false" default="" />
		<cfargument name="Login_Token" required="false" default="" />
		<cfargument name="Login_Date_Time" required="false" default="" />
		<cfargument name="Institution1_ID" required="false" default="" />
		<cfargument name="Institution2_ID" required="false" default="" />
		<cfargument name="Institution3_ID" required="false" default="" />
		<cfargument name="Enrollment_Date" required="false" default="" />
		<cfargument name="Attendance_Level" required="false" default="" />
		<cfargument name="Degree_Level" required="false" default="" />
		<cfargument name="Notes" required="false" default="" />
		<cfargument name="Payment_Method" required="false" default="" />
		<cfargument name="Account_Type" required="false" default="" />
		<cfargument name="Routing_Number" required="false" default="" />
		<cfargument name="Account_Number" required="false" default="" />
		<cfargument name="GDS_Match" required="false" default="" />
		<cfargument name="AB540" required="false" default="" />
		<cfargument name="Date_Created" required="false" default="" />
		<cfargument name="claimed" required="false" default="" />
		<cfargument name="claimStatus" required="false" default="" />
		<cfargument name="scholarshipTypes" required="false" default="" />
		<cfargument name="programYears" required="false" default="" />
		<cfargument name="scholarshipIDs" required="false" default="" />
		<cfargument name="studentIDs" required="false" default="" />
		<cfargument name="workshopIDs" required="false" default="" />
		<cfargument name="organizationIDs" required="false" default="" />
		<cfargument name="siteIDs" required="false" default="" />
		<cfargument name="organizerIDs" required="false" default="" />
		<cfargument name="managerIDs" required="false" default="" />
		<cfargument name="countyIDs" required="false" default="" />
		<cfargument name="regionIDs" required="false" default="" />

		<cfset var recs = "">
		<cfstoredproc datasource="#getDatasource()#" procedure="readScholarship">
			<cfprocparam value="#arguments.Scholarship_ID#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(arguments.Scholarship_ID)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Deleted#" cfsqltype="CF_SQL_BIT" null="#IIf(NOT IsBoolean(arguments.Deleted), true, false)#" />
			<cfprocparam value="#arguments.Student_ID#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(arguments.Student_ID)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Claim_ID#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Claim_ID)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Claim_Date#" cfsqltype="" null="#IIf(NOT IsDate(arguments.Claim_Date), true, false)#" />
			<cfprocparam value="#arguments.Cohort#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(arguments.Cohort)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Scholarship_Type#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Scholarship_Type)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.PBS#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(arguments.PBS)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Research_ID#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Research_ID)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.First_Name#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.First_Name)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Last_Name#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Last_Name)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.SSN#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.SSN)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.DOB#" cfsqltype="" null="#IIf(NOT IsDate(arguments.DOB), true, false)#" />
			<cfprocparam value="#arguments.Gender#" cfsqltype="CF_SQL_CHAR" null="#IIf(Len(Trim(arguments.Gender)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Race_Ethnicity#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Race_Ethnicity)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Address#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Address)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.City#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.City)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Zip_Code#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Zip_Code)) eq 0, true, false)#" />
			<cfprocparam value="#LCase(arguments.Email)#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Email)) eq 0, true, false)#" />
			<cfprocparam value="#formatPhone(arguments.Phone1)#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Phone1)) eq 0, true, false)#" />
			<cfprocparam value="#formatPhone(arguments.Phone2)#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Phone2)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Password#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Password)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.High_School#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.High_School)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.High_School_ID#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(arguments.High_School_ID)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Graduation_Month#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(arguments.Graduation_Month)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Graduation_Year#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(arguments.Graduation_Year)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Volunteer#" cfsqltype="CF_SQL_BIT" null="#IIf(NOT IsBoolean(arguments.Volunteer), true, false)#" />
			<cfprocparam value="#arguments.Authorized#" cfsqltype="CF_SQL_BIT" null="#IIf(NOT IsBoolean(arguments.Authorized), true, false)#" />
			<cfprocparam value="#arguments.Authorized_By#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Authorized_By)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Authorized_Signature#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Authorized_Signature)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Orientation_Completed#" cfsqltype="CF_SQL_BIT" null="#IIf(NOT IsBoolean(arguments.Orientation_Completed), true, false)#" />
			<cfprocparam value="#arguments.Login_Token#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Login_Token)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Login_Date_Time#" cfsqltype="CF_SQL_DATE" null="#IIf(NOT IsDate(arguments.Login_Date_Time), true, false)#" />
			<cfprocparam value="#arguments.Institution1_ID#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(arguments.Institution1_ID)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution2_ID#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(arguments.Institution2_ID)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution3_ID#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(arguments.Institution3_ID)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Enrollment_Date#" cfsqltype="" null="#IIf(NOT IsDate(arguments.Enrollment_Date), true, false)#" />
			<cfprocparam value="#arguments.Attendance_Level#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Attendance_Level)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Degree_Level#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Degree_Level)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Notes#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Notes)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Payment_Method#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Payment_Method)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Account_Type#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Account_Type)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Routing_Number#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Routing_Number)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Account_Number#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Account_Number)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.GDS_Match#" cfsqltype="CF_SQL_BIT" null="#IIf(NOT IsBoolean(arguments.GDS_Match), true, false)#" />
			<cfprocparam value="#arguments.AB540#" cfsqltype="CF_SQL_BIT" null="#IIf(NOT IsBoolean(arguments.AB540), true, false)#" />
			<cfprocparam value="#arguments.Date_Created#" cfsqltype="CF_SQL_TIMESTAMP" null="#IIf(NOT IsDate(arguments.Date_Created), true, false)#" />
			<cfprocparam value="#arguments.claimed#" cfsqltype="CF_SQL_BIT" null="#IIf(NOT IsBoolean(arguments.claimed), true, false)#" />
			<cfprocparam value="#arguments.claimStatus#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.claimStatus)) eq 0, true, false)#" />	
			<cfprocparam value="#arguments.scholarshipTypes#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.scholarshipTypes)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.programYears#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.programYears)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.scholarshipIDs#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.scholarshipIDs)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.studentIDs#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.studentIDs)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.workshopIDs#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.workshopIDs)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.organizationIDs#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.organizationIDs)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.siteIDs#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.siteIDs)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.organizerIDs#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.organizerIDs)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.managerIDs#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.managerIDs)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.countyIDs#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.countyIDs)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.regionIDs#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.regionIDs)) eq 0, true, false)#" />
			<cfprocresult name="recs" />
		</cfstoredproc>
		<cfreturn recs />
	</cffunction>

	<cffunction name="save" access="public" output="false" returntype="any">
		<cfargument name="scholarship" required="true" type="assets.calgrants.com.bo.Scholarship" />

		<cfstoredproc datasource="#getDatasource()#" procedure="saveScholarship">
			<cfprocparam value="#scholarship.getScholarship_ID()#" cfsqltype="CF_SQL_INTEGER" variable="id" type="inout" null="false" />
			<cfprocparam value="#scholarship.getDeleted()#" cfsqltype="CF_SQL_BIT" null="false" />
			<cfprocparam value="#scholarship.getStudent_ID()#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(scholarship.getStudent_ID())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getClaim_ID()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getClaim_ID())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getClaim_Date()#" cfsqltype="CF_SQL_DATE" null="#IIf(Len(Trim(scholarship.getClaim_Date())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getCohort()#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(scholarship.getCohort())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getScholarship_Type()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getScholarship_Type())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getPBS()#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(scholarship.getPBS())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getResearch_ID()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getResearch_ID())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getFirst_Name()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getFirst_Name())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getLast_Name()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getLast_Name())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getSSN()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getSSN())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getDOB()#" cfsqltype="CF_SQL_DATE" null="#IIf(Len(Trim(scholarship.getDOB())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getGender()#" cfsqltype="CF_SQL_CHAR" null="#IIf(Len(Trim(scholarship.getGender())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getRace_Ethnicity()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getRace_Ethnicity())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getAddress()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getAddress())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getCity()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getCity())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getZip_Code()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getZip_Code())) eq 0, true, false)#" />
			<cfprocparam value="#LCase(scholarship.getEmail())#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getEmail())) eq 0, true, false)#" />
			<cfprocparam value="#formatPhone(scholarship.getPhone1())#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getPhone1())) eq 0, true, false)#" />
			<cfprocparam value="#formatPhone(scholarship.getPhone2())#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getPhone2())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getPassword()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getPassword())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getHigh_School()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getHigh_School())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getHigh_School_ID()#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(scholarship.getHigh_School_ID())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getGraduation_Month()#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(scholarship.getGraduation_Month())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getGraduation_Year()#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(scholarship.getGraduation_Year())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getVolunteer()#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(scholarship.getVolunteer())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getAuthorized()#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(scholarship.getAuthorized())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getAuthorized_By()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getAuthorized_By())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getAuthorized_Signature()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getAuthorized_Signature())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getOrientation_Completed()#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(scholarship.getOrientation_Completed())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getLogin_Token()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getLogin_Token())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getLogin_Date_Time()#" cfsqltype="CF_SQL_DATE" null="#IIf(Len(Trim(scholarship.getLogin_Date_Time())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getInstitution1_ID()#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(scholarship.getInstitution1_ID())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getInstitution2_ID()#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(scholarship.getInstitution2_ID())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getInstitution3_ID()#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(scholarship.getInstitution3_ID())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getEnrollment_Date()#" cfsqltype="CF_SQL_DATE" null="#IIf(Len(Trim(scholarship.getEnrollment_Date())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getAttendance_Level()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getAttendance_Level())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getDegree_Level()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getDegree_Level())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getNotes()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getNotes())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getPayment_Method()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getPayment_Method())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getAccount_Type()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getAccount_Type())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getRouting_Number()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getRouting_Number())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getAccount_Number()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(scholarship.getAccount_Number())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getGDS_Match()#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(scholarship.getGDS_Match())) eq 0, true, false)#" />
			<cfprocparam value="#scholarship.getAB540()#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(scholarship.getAB540())) eq 0, true, false)#" />
		</cfstoredproc>
		<cfreturn id />
	</cffunction>

	<cffunction name="destroy" access="public" output="false" returntype="any">
		<cfargument name="Scholarship_ID" required="true" />

		<cfstoredproc datasource="#getDatasource()#" procedure="destroyScholarship">
			<cfprocparam value="#arguments.Scholarship_ID#" cfsqltype="CF_SQL_INTEGER" null="false" />
			<cfprocparam value="true" cfsqltype="CF_SQL_BIT" null="false" />
		</cfstoredproc>
		<cfreturn true />
	</cffunction>

</cfcomponent>

